Create Table fee_mode(
[f_id] [int] NOT NULL,
[f_name] [varchar](20) NOT NULL,
primary key("f_id")
);

INSERT [dbo].[fee_mode] ( [f_id], [f_name]) VALUES (1, N'物业管理费');
INSERT [dbo].[fee_mode] ( [f_id], [f_name]) VALUES (2, N'车位管理费');



Create Table fee_info(
[fee_id] [int] IDENTITY(1,1) NOT NULL, 
[fee_mode_id] [int] NOT NULL,
[fee_mode] [varchar](20) NOT NULL,
[amount] [DECIMAL](6,2) NOT NULL,
[b_id] [int] NOT NULL,
[b_name] [varchar](30) NOT NULL,
[q_id] [int] NOT NULL,
[q_name] [varchar](30) NOT NULL,
[room_num] [varchar](10) NOT NULL,
[description] [varchar](200) NULL,
[state] [int] NOT NULL,
[valid_time] [datetime] NOT NULL,
[modify_time] [datetime] NOT NULL,
[user_id][int] NOT NULL,
[user_name] [varchar](50) NOT NULL
primary key("fee_id")
);

INSERT [dbo].[fee_info] ( [fee_mode_id],[fee_mode],[amount],[b_id], [b_name], [q_id], [q_name],[room_num],[description],[state],[modify_time],[user_id],[user_name],[valid_time]) VALUES (1, N'物业管理费',N'3496.23',1,N'一号楼',1,N'保利名都',N'2601',N'备注',0, CAST(N'2024-04-23T20:00:00.000' AS DateTime), 2024001, N'admin',CAST(N'2025-04-23T20:00:00.000' AS DateTime));

INSERT [dbo].[fee_info] ( [fee_mode_id],[fee_mode],[amount],[b_id], [b_name], [q_id], [q_name],[room_num],[description],[state],[modify_time],[user_id],[user_name],[valid_time]) VALUES (2, N'车位管理费',N'496.23',1,N'一号楼',1,N'保利名都',N'2601',N'备注',1, CAST(N'2024-04-23T20:00:00.000' AS DateTime), 2024001, N'admin',CAST(N'2025-04-23T20:00:00.000' AS DateTime));

INSERT [dbo].[fee_info] ( [fee_mode_id],[fee_mode],[amount],[b_id], [b_name], [q_id], [q_name],[room_num],[description],[state],[modify_time],[user_id],[user_name],[valid_time]) VALUES (2, N'车位管理费',N'496.23',1,N'一号楼',1,N'保利名都',N'2601',N'备注',-1, CAST(N'2024-04-23T20:00:00.000' AS DateTime), 2024001, N'admin',CAST(N'2025-04-23T20:00:00.000' AS DateTime));
